package LawsonTransformJava.data;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;


public class TblReview {

	public int      company		=0;
	public int  	employee	=0;
	public int  	seq_nbr		=0;
	public Date 	sched_date	=null;
	public String 	code		=null;
	public Date		actual_date	=null;
	public String 	rating		=null;
	public String 	last_name	=null;
	public String	first_name	=null;
	public String	middle_init	=null;
	public int		by_employee	=0;
	public Date     date_stamp	=null;
	public int 		time_stamp	=0;
	public String	user_id		=null;
	public String	l_index		=null;
	public String	l_atrev_ss_sw	=null;
	public String	model_name	=null;
	public float    percentile	=0;
	public float	perf_score	=0;
	public float	perf_weighting	=0;
	public float    goal_score	=0;
	public float    goal_weighting	=0;
	public float    total_score	=0;
	public String   description	=null;
	public String   rev_schedule	=null;
	public Date     next_review	=null;
	public String   next_rev_code	=null;
	public Date     last_review	=null;
	public int      review_flag	=0;
	
	private DateFormat df = new SimpleDateFormat("MM/dd/yyyy");
	private DateFormat df2 = new SimpleDateFormat("yyyyMMdd");
	private String text; 
	
	public void setCompany(int company) {
		this.company = company;
	}
	public void setEmployee(int employee) {
		this.employee = employee;
	}
	public void setSeq_nbr(int seq_nbr) {
		this.seq_nbr = seq_nbr;
	}
	public void setSched_date(Date sched_date) {
		this.sched_date = sched_date;
	}
	public void setCode(String code) {
		this.code = code;
	}
	public void setActual_date(Date actual_date) {
		this.actual_date = actual_date;
	}
	public void setRating(String rating) {
		this.rating = rating;
	}
	public void setLast_name(String last_name) {
		this.last_name = last_name;
	}
	public void setFirst_name(String first_name) {
		this.first_name = first_name;
	}
	public void setMiddle_init(String middle_init) {
		this.middle_init = middle_init;
	}
	public void setBy_employee(int by_employee) {
		this.by_employee = by_employee;
	}
	public void setDate_stamp(Date date_stamp) {
		this.date_stamp = date_stamp;
	}
	public void setTime_stamp(int time_stamp) {
		this.time_stamp = time_stamp;
	}
	public void setUser_id(String user_id) {
		this.user_id = user_id;
	}
	public void setL_index(String l_index) {
		this.l_index = l_index;
	}
	public void setL_atrev_ss_sw(String l_atrev_ss_sw) {
		this.l_atrev_ss_sw = l_atrev_ss_sw;
	}
	public void setModel_name(String model_name) {
		this.model_name = model_name;
	}
	public void setPercentile(float percentile) {
		this.percentile = percentile;
	}
	public void setPerf_score(float perf_score) {
		this.perf_score = perf_score;
	}
	public void setPerf_weighting(float perf_weighting) {
		this.perf_weighting = perf_weighting;
	}
	public void setGoal_score(float goal_score) {
		this.goal_score = goal_score;
	}
	public void setGoal_weighting(float goal_weighting) {
		this.goal_weighting = goal_weighting;
	}
	public void setTotal_score(float total_score) {
		this.total_score = total_score;
	}
	public void setDescription(String description) {
		this.description = description;
	}
	public void setRev_schedule(String rev_schedule) {
		this.rev_schedule = rev_schedule;
	}
	public void setNext_review(Date next_review) {
		this.next_review = next_review;
	}
	public void setNext_rev_code(String next_rev_code) {
		this.next_rev_code = next_rev_code;
	}
	public void setLast_review(Date last_review) {
		this.last_review = last_review;
	}
	public void setReview_flag(int review_flag) {
		this.review_flag = review_flag;
	}
	
// Getters	
	
	public int getCompany() {
		return company;
	}
	public int getEmployee() {
		return employee;
	}
	public int getSeq_nbr() {
		return seq_nbr;
	}
	public String getSched_date() {
		if (sched_date==null)
		{text = "";}
		else
		{String date =(sched_date!=null?df2.format(sched_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(sched_date).toString() + "\"";;}}
		return text;			
	}
	public String getCode() {
		if (code==null||code.equals(""))
		{text = "";}
	else
		{text = "\""+code+"\"";}
	return text;			
	}
	public String getActual_date() {
		if (actual_date==null)
		{text = "";}
		else
		{String date =(actual_date!=null?df2.format(actual_date).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(actual_date).toString() + "\"";;}}
		return text;	
	}
	public String getRating() {
		if (rating==null||rating.equals(""))
		{text = "";}
	else
		{text = "\""+rating+"\"";}
	return text;				
	}
	public String getLast_name() {
		if (last_name==null||last_name.equals(""))
		{text = "";}
	else
		{text = "\""+last_name+"\"";}
	return text;			
	}
	public String getFirst_name() {
		if (first_name==null||first_name.equals(""))
		{text = "";}
	else
		{text = "\""+first_name+"\"";}
	return text;			
	}
	public String getMiddle_init() {
		if (middle_init==null||middle_init.equals(""))
		{text = "";}
	else
		{text = "\""+middle_init+"\"";}
	return text;				
	}
	public int getBy_employee() {
		return by_employee;
	}
	public String getDate_stamp() {
		if (date_stamp==null)
		{text = "";}
		else
		{String date =(date_stamp!=null?df2.format(date_stamp).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(date_stamp).toString() + "\"";;}}
		return text;	
	}
	public int getTime_stamp() {
		return time_stamp;
	}
	public String getUser_id() {
		if (user_id==null||user_id.equals(""))
		{text = "";}
	else
		{text = "\""+user_id+"\"";}
	return text;			
	}
	public String getL_index() {
		if (l_index==null||l_index.equals(""))
		{text = "";}
	else
		{text = "\""+l_index+"\"";}
	return text;			
	}
	public String getL_atrev_ss_sw() {
		if (l_atrev_ss_sw==null||l_atrev_ss_sw.equals(""))
		{text = "";}
	else
		{text = "\""+l_atrev_ss_sw+"\"";}
	return text;			
	}
	public String getModel_name() {
		if (model_name==null||model_name.equals(""))
		{text = "";}
	else
		{text = "\""+model_name+"\"";}
	return text;			
	}
	public float getPercentile() {
		return percentile;
	}
	public float getPerf_score() {
		return perf_score;
	}
	public float getPerf_weighting() {
		return perf_weighting;
	}
	public float getGoal_score() {
		return goal_score;
	}
	public float getGoal_weighting() {
		return goal_weighting;
	}
	public float getTotal_score() {
		return total_score;
	}
	public String getDescription() {
		if (description==null||description.equals(""))
		{text = "";}
	else
		{text = "\""+description+"\"";}
	return text;			
	}
	public String getRev_schedule() {
		if (rev_schedule==null||rev_schedule.equals(""))
		{text = "";}
	else
		{text = "\""+rev_schedule+"\"";}
	return text;				
	}
	public String getNext_review() {
		if (next_review==null)
		{text = "";}
		else
		{String date =(next_review!=null?df2.format(next_review).toString():""); 
		if (date.equals("17000101"))
			{text = "";}
		else
			{text ="\"" + df.format(next_review).toString() + "\"";;}}
		return text;	
	}
	public String getNext_rev_code() {
		if (next_rev_code==null||next_rev_code.equals(""))
		{text = "";}
	else
		{text = "\""+next_rev_code+"\"";}
	return text;				
	}
	public String getLast_review() {
		String date =(last_review!=null?df.format(last_review).toString():""); 
		return date;
	}
	public int getReview_flag() {
		return review_flag;
	}
	
	
}
